SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_AddAvailableField]
    (
      @JOL_Field_Name VARCHAR(50),
      @JOL_Field_Campus VARCHAR(50),
      @JOL_Field_SeatNumber INT,
      @JOL_Field_Money MONEY,
      @JOL_Field_IsProvideMultimedia BIT,
      @JOL_Field_Remark NTEXT,
      @JOL_Field_AddTime DATETIME,
      @JOL_Field_AddUser VARCHAR(50)
    )
AS 
    INSERT  INTO dbo.JOL_AvailableField
            (
              JOL_Field_Name,
              JOL_Field_Campus,
              JOL_Field_SeatNumber,
              JOL_Field_Money,
              JOL_Field_IsProvideMultimedia,
              JOL_Field_Remark,
              JOL_Field_AddTime,
              JOL_Field_AddUser,
              JOL_Field_UpdateTime,
              JOL_Field_UpdateUser
            )
    VALUES  (
              @JOL_Field_Name, -- JOL_Field_Name - varchar(50)
              @JOL_Field_Campus, -- JOL_Field_Campus - varchar(50)
              @JOL_Field_SeatNumber, -- JOL_Field_SeatNumber - int
              @JOL_Field_Money, -- JOL_Field_Money - money
              @JOL_Field_IsProvideMultimedia, -- JOL_Field_IsProvideMultimedia - bit
              @JOL_Field_Remark, -- JOL_Field_Remark - ntext
              GETDATE(), -- JOL_Field_AddTime - datetime
              @JOL_Field_AddUser, -- JOL_Field_AddUser - varchar(50)
              NULL, -- JOL_Field_UpdateTime - datetime
              NULL  -- JOL_Field_UpdateUser - varchar(50)
            )
GO
